package com.itheima.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface ReportMapper {
    @Select("select if (gender=1,'男性员工','女性员工' ) name, count(*) value from emp group by gender")
    List<Map<String, Object>> getGenderInfo();

    List<Map<String, Object>> getJobInfo();

    List<Map<String, Object>> getDegreeInfo();

    List<Map<String, Object>> getClazzInfo();
}
